My Stuff
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
-
Re: Item Receipt vs. PO Line Data Formula (Inventory Detail Status)
Hi @jmack_admin, Please try this formula using a Formula (Numeric) field with Summary Type = Maximum: MAX{appliedtotransaction.quantity} - SUM(CASE WHEN {inventorydetail.status} = 'Bad' THE…1 -
Re: Work order completion with backflush after inventory issue generates error
Hi @moonking, I did further tests on the scenario that you provided and I noted that once you issue the components, it does not show in the Committed column, but shows in the Used In Build column ins…1 -
Re: Inventory Counts Review
Hi there @Brad3987399, I checked my resources on this and found that it is not yet possible to export the Inventory Worksheet table data. There is an enhancement logged requesting for this ability: E…2 -
Re: Save search with calculating inventory aging formula question
Hi @Angel Chang, Here's my understanding of the logic that you mentioned: CASE WHEN {Ending Quantity} > {Less than 3 Months Inputs} THEN {Les than 3 Months Inputs} ELSE {Ending Quantity} END …1 -
Re: Saved search of last completed work order operation
Hi @Johnny Cash, I ran some tests on this, and I noticed that there is a Status field for the Manufacturing Operations. I think we can use this field in a formula to get the Min and Max value of the …1
